| |
48 Search Results Found |
| 1 |
Forum: RAC & Failsafe «»
Posted on: Thu, 17 May 2018 10:50 «»
By: sarahLian
Root.sh failed: ORA-39510: CRS error performing start on instance '+ASM1' on '+ASM'
…Hello,
I have some issues with the installation of Oracle RAC 12.2 on RHEL 7. Could you please help me with this issue ?
Thanks in advance.
The root.sh failed with the following error:
ORA-39510: CRS error performing start on instance '+ASM1' …
|
| 2 |
Forum: Server Administration «»
Posted on: Wed, 06 December 2017 21:08 «»
By: lzfhope
Re: global temporay table does not work!
…Today,i found that init parameter "temp_undo_enabled" is set to true,which is the only changed parameter recently!
Have a try,restored it to "false"!
as a result,global temporary table(on commit preserve) could still hold data …
|
| 3 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 29 November 2017 05:12 «»
By: dba4oracle
Re: trigger impacting performance
…Hi,
Below is DDL of master table and trigger source
temp(staging) table is same as master table but no constraints,index,partition and no trigger attached to it
CREATE TABLE "schema1"."Master1"
( "…
|
| 4 |
Forum: SQL & PL/SQL «»
Posted on: Sun, 27 August 2017 13:00 «»
By: rkrishna
Re: Bulk Inserts with CLOB column Slower in Oracle 12c than Oracle 11g
…are in the verge of making the decision to upgrade to 12c, and this extremely slow performance on Inserts is a major blocker. The expectation is that 12c should be at least as fast as 11g, if not better. I am looking for any suggestion on whether we need …
|
| 5 |
Forum: Linux «»
Posted on: Tue, 23 August 2016 02:47 «»
By: trantuananh24hg
Tips for Installation 11gr2 on RHEL6
…ago, I finished installation the 11gr2 on RHEL6, and there are some tips here:
1. Install the requirement pacakges
[root@spsdev ~]#yum install local compat-libstdc++-33*
[root@spsdev ~]#yum install local libaio-devel-0.*
[root@spsdev ~]#yum …
|
| 6 |
Forum: Marketplace «»
Posted on: Mon, 22 August 2016 10:14 «»
By: Michel Cadot
Re: McDP: like expdp/impdp Data Pump programs and much more
…
DDL command
In the same vein than the previous command, CONTENT, McDP allows you to get the DDL of all or part of a database, with the transformation you want, using the DDL command.
Its syntax is:
McDP [<logon>] { -ddl | --ddl } [<…
|
| 7 |
Forum: Server Administration «»
Posted on: Mon, 30 September 2013 00:33 «»
By: ishika_20
ORA-30967: operation directly on the Path Table (during CSSCAN process)
…All,
While doing scanning of character set, error occurred in between.
Kindly assist me to solve the problem.
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application …
|
| 8 |
Forum: Performance Tuning «»
Posted on: Thu, 11 April 2013 10:52 «»
By: Michel Cadot
Re: How to find out session consuming high resource in the past?
…Ah! you were talking about the columns... I thought the view... sorry.
They indeed are there only in 11g:
mikb2=MIKB2/ILLUVATAR MICHEL> desc DBA_HIST_ACTIVE_SESS_HISTORY
Name Null? Type…
|
| 9 |
Forum: Application Express, ORDS & MOD_PLSQL «»
Posted on: Sun, 24 February 2013 07:10 «»
By: BLROracle
create remote file with util_file
…Hello,
i´am a newon pl/sql and i have question about util_file.
My environment:
Database is installed on some server, which i have no access.
I have to export some data from this database.
1.At first, i have to create some csv and xml files.
…
|
| 10 |
Forum: Performance Tuning «»
Posted on: Wed, 17 October 2012 15:15 «»
By: segan1415
Re: NOLOGGING in Oracle 11gr2
…have changed sequence cache to 100,000 per your recommendation. This change chops about .4ms from my elapsed time per execution. The first two reports (907-908) were run at the same load volume as all my previous reports, then I decided to run my load …
|
| 11 |
Forum: Performance Tuning «»
Posted on: Wed, 17 October 2012 10:00 «»
By: segan1415
Re: NOLOGGING in Oracle 11gr2
…seems from the new AWRRPT, I am now swapping log files every fifteen minutes (since there is only 1 switch, I ran a second awrrpt from 801-803 and there was 2 switches - confirming this)
AWRRPT 801-802 (50M REDO LOG FILES)
Toggle Spoiler
WORKLOAD…
|
| 12 |
Forum: Performance Tuning «»
Posted on: Wed, 17 October 2012 02:17 «»
By: Roachcoach
Re: NOLOGGING in Oracle 11gr2
…those who cannot download, contents in the spoiler section to save a wall of text
Toggle Spoiler
WORKLOAD REPOSITORY report for
DB Name DB Id Instance Inst Num Startup Time Release RAC…
|
| 13 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 06 September 2012 10:24 «»
By: Michel Cadot
Re: Remote Pipeline or Remote sys_refcursor
…
No, it's me, I was not clear, I was going back to your initial question and ask if you can't from your application open a connection to the other (remote) database and directly get the result from it instead of getting through a db link.
For your …
|
| 14 |
Forum: SQL & PL/SQL «»
Posted on: Sat, 11 February 2012 02:04 «»
By: aallan
Re: Create HTML table problem in email
…Michel for reply,
this is my code:
Create Or Replace Procedure Sale.Html_Email_With_Attach(
P_To In Varchar2,
P_Cc In Varchar2 Default Null,
P_Bcc In Varchar2 Default Null,
P_From In …
|
| 15 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 06 February 2012 07:42 «»
By: aallan
Re: Create HTML table problem in email
…you...
i searched and found this code:
Create Or Replace Procedure Sale.Html_Email_With_Attach(
P_To In Varchar2,
P_Cc In Varchar2 Default Null,
P_Bcc In Varchar2 Default Null,
P_From In …
|
| 16 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 06 February 2012 02:03 «»
By: aallan
Create HTML table problem in email
…Dears;
I used this procedure to send html email:
Create Or Replace Procedure Sale.Html_Email(
P_To In Varchar2,
P_Cc In Varchar2 Default Null,
P_Bcc In Varchar2 Default Null,
P_From In …
|
| 17 |
Forum: Server Administration «»
Posted on: Wed, 01 February 2012 00:32 «»
By: x-oracle
Re: ora 01092 oracle instance terminated
…i am sending you a complite steps of how can we create a manul database you just read it and just change the path and name of the database as you want
first
1. Decide the name of New database
2. ORACLE_SID=ORA10G... (set into Env variable )
3…
|
| 18 |
Forum: Server Administration «»
Posted on: Mon, 19 December 2011 23:20 «»
By: Bilal Khan
DATABASE CREATION
…all.
i wana create database in oracle 10g, but it display error mesage.
i follow following steps
C:\SET ORACLE_SID = ALI
THEN CREATE PASSWORD FILE,AND STARTUP THE PFILE, THEN RUN FOLLOWING CODE TO CREATE THE DATABASE.
CREATE DATABASE ali
…
|
| 19 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 13 October 2011 06:05 «»
By: muktha_22
Re: Problem in DBMS_FILE_TRANSFER.PUT_FILE
…Michel/Jhon,
Still I am not able understand the issue.
SQL> create database link link8 connect to bkpusr identified by Issl#2010 using '10GTEST';
Database link created.
SQL> select * from tab@link8;
TNAME …
|
| 20 |
Forum: Performance Tuning «»
Posted on: Fri, 02 September 2011 07:08 «»
By: msol25
Re: how we can match variable sga using v$sga and v$sgastat views
…Michel,
Please find details :
SQL> select * from v$sga;
NAME VALUE
-------------------- ----------
Fixed Size…
|
| 21 |
Forum: Linux «»
Posted on: Mon, 02 May 2011 13:10 «»
By: juniorpeardba
Re: SQL Plus no access
…Hi,
log file from installation
more installActions2011-04-28_02-48-23PM.log
Using paramFile: /opt/oracle/Disk1/install/oraparam.ini
Checking Temp space: must be greater than 80 MB. Actual 2693 MB Passed
Checking swap space: must be greater …
|
| 22 |
Forum: Server Administration «»
Posted on: Mon, 02 May 2011 06:47 «»
By: juniorpeardba
Re: incorrect version of oracle
…Hello,
here are the results of the log file
more installActions2011-04-28_02-48-23PM.log
Using paramFile: /opt/oracle/Disk1/install/oraparam.ini
Checking Temp space: must be greater than 80 MB. Actual 2693 MB Passed
Checking swap space…
|
| 23 |
Forum: Server Administration «»
Posted on: Mon, 27 December 2010 04:34 «»
By: debakor
ORA-01079
…i want to create manual database its give the error message ORA-01092 Here i give the create database command and my parameter file.
SQL> create database dba16
2 MAXLOGFILES 5
3 MAXLOGMEMBERS 5
4 …
|
| 24 |
Forum: Server Administration «»
Posted on: Thu, 10 June 2010 23:10 «»
By: reym21
db creation ctl error
…Pls. help me... I need this dB by Saturday! Thank you in advanced.
It's been 2 days from now that I'm bugging with this kind of error in my manual dB creation. I used DBCA first but we had a default directory settings, that's why I resorted to create the…
|
| 25 |
Forum: Unix «»
Posted on: Wed, 19 May 2010 12:38 «»
By: medamadhu1
Re: unix shell script
…Rajendhran,
Thanks for your reply.It's actually a long task which i have broken into two parts.I was able to write a script for the 1st part but i need some help with the 2nd part.Please have a look at the whole task and let me know if u have any …
|
| 26 |
Forum: Weblogic & Application Server «»
Posted on: Thu, 28 January 2010 13:11 «»
By: her_fedo
OracleAS - Report Server
…Hi, I'm runnig Application Server on my computer, starting OC4J and namingservice, I could run my forms the issue is with the reports, show me: Unable to connect to report server: rep_2kgpkc1
I have rep_2kgpkc1.conf file and modified rwnetwork.conf. I …
|
| 27 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 13 February 2009 03:25 «»
By: deepbans
Re: Performance issue while runningthe query
…Dr.Raghunathan,
Here we are accessing each table remotely and each table contain huge number of records.
The original query is even too long.I have break the query and have created a temporary physical table(not global temp table) on my local …
|
| 28 |
Forum: Replication «»
Posted on: Mon, 22 September 2008 02:42 «»
By: PayoRanger
Add_Master_Database fails
…Everybody,
thanks in advance for your help. I'm trying to configure and run replication. I have two PC's running as Oracle servers, having both of them the same configuration:
Windows XP Pro
Oracle 11g Enterprise Edition
First server is …
|
| 29 |
Forum: Replication «»
Posted on: Fri, 27 April 2007 13:08 «»
By: thierno
Multimaster Replication
…All, I'm not good in english but I will try to decribe my problem.
I want to do replication between to database Oracle 10.0.2.0.1
There are scripts given to deal with. I verify that in the both databases parameters are correct.
I execute this script at…
|
| 30 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 23 March 2007 13:41 «»
By: Michel Cadot
Re: Script prob after changing from Oracle 9i to 10g R2 ORA-02021 ORA-30041
…
You cannot execute a DDL on a remote database, nobody can, this is a fact. However you can call a remote procedure that executes a DDL, for instance dbms_utility.exec_ddl_statement.
There is no quota on temp tablespace, they are useless, you don't …
|
| 31 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 23 March 2007 12:20 «»
By: t.summerfield
Script prob after changing from Oracle 9i to 10g R2 ORA-02021 ORA-30041
…
I have recently formatted and setup one of the servers at work (windows server 2003) and have installed Oracle 10g R2 on it. It previously had Oracle 9i
My role in this is as the DBA and as such I have very little SQL experience!
I have a …
|
| 32 |
Forum: Performance Tuning «»
Posted on: Tue, 06 March 2007 20:18 «»
By: Tom_webex
How to tuning our oracle product server?
… We have a product server,it can work normal daily(speed can ok),but when we deal with large mount of data(insert,update,delete),the deal speed is very slow,I have the statspack report,pls tell me how to tuning?
THANKS!
STATSPACK report for
…
|
| 33 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 12 July 2006 21:50 «»
By: rleishman
Re: How to compare two huge tables in Oracle?
…@JRowbottoms advice is solid gold. Use it.
It performs almost exactly the same algorithm as the MINUS SQL (internally), but it will perform the sort of the remote table on the remote database! Not on the local database.
The problem with the MINUS …
|
| 34 |
Forum: Networking and Gateways «»
Posted on: Mon, 20 March 2006 17:42 «»
By: nmacdannald
Re: Connecting to Remote Server
…links.
Okay, here is the deal. I just spent two days reading about something that a person can explain in two minutes.
1) Make sure your tnsnames.ora have the same correct entries on both local and remote databases.
then lsnrctl reload
The …
|
| 35 |
Forum: Networking and Gateways «»
Posted on: Mon, 20 March 2006 17:33 «»
By: nmacdannald
Database links explained...
…links.
Okay, here is the deal. I just spent two days reading about something that a person can explain in two minutes.
1) Make sure your tnsnames.ora have the same correct entries on both local and remote databases.
then lsnrctl reload
The …
|
| 36 |
Forum: Networking and Gateways «»
Posted on: Mon, 20 March 2006 17:28 «»
By: nmacdannald
How to create a database link
…links.
Okay, here is the deal. I just spent two days reading about something that a person can explain in two minutes.
Make sure your tnsnames.ora have the same correct entries.
then lsnrctl reload
create a public database link on the local …
|
| 37 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 15 February 2006 01:28 «»
By: sxramas
Database Link
…have a database link STG_DEV in DEV environment which connects to TEMP instance.
create database link STG_DEV
connect to STG
identified by stg
using 'TEMP';
TEMP database is up and running fine.Iam able to connect it.Still I get this error.
When I …
|
| 38 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 10 November 2005 11:08 «»
By: ebegoli
Copying BLOB over DB_LINK
…Hi,
I am trying to copy a blob over the db_link.
Just doing a plain read gives : ORA-22922 Can not remotely access LOB locator.
Suggestion by Tom Kyte is to create temporary global table,
and copy the blob over into it.
insert into temp …
|
| 39 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 10 March 2005 05:57 «»
By: Ken Jones
Re: Cursor Loop
…Todd, sorry for being a pain in the derriere but I have another question. I have created a directory on the filesystem and would like to write the above output into a file there. BUT I do not know how to reference what I need to write - see below:-
…
|
| 40 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 10 March 2005 05:42 «»
By: Ken Jones
Re: Cursor Loop
…
v_rc sys_refcursor;
v_user dba_users%rowtype;
v_node orcladmin.node_tns.node_tns%type;
begin
for rec_node in (select node_tns from orcladmin.node_tns where dbname like 'GM%' and dbname not in ('GMDU7','GMPA'))
loop
open v_rc for '…
|
Blog
Search
Help
Members
Register
Login
Home